CREATING SLICER AND KIP CARD
11
Creating Year Slicer
STEP 1- At the visualization tab select slicer
visual. Select date table then select year from date hierarchy
STEP 2 - Change to
between by clicking slicer ellipsis
STEP 3 -Click
on numeric input, Text size=10, Font=Arial Black, Font color=Custom 2e1039
STEP 4-Turn
on the background, make the color custom #bda6c6 and 0%trnasparnsy
STEP 5- Turn Slider header and the visual header OFF. Turn on the shadow
STEP 6- Go to General X position = 912, y position = 0, width = 192, height = 110
Follow the GIF below to apply the above steps
Creating and formatting
GPM% KPI
STEP7- Copy and
paste the slicer visual, Remove the year field from the slicer, change the
slicer visual to card visual then drag and drop the gross profit margin field
from the sales table
STEP 8- Click
Data Label make the color custom #bda6c6, Text Size= 33, Font= DIN and
for value decimal place =1
STEP 9- Set
Category Off, Word Wrap ON, Turn Title On, type GPM% for the title,
make the color = custom #bda6c6, Alignment
Center, Text Size=22, Font =Arial Black
Follow the GIF below to apply the above steps
Creating and formatting
YOY% KPI
STEP 10- Copy and
paste the KPI visual, Remove the GPM% field then drag and drop the YOY% kpi
field from the sales table
STEP 11- Click
Data Label then click data label function format by filed value, based on KPI
Arrow field
STEP 12- Click
title change the title to YOY%
Follow
the GIF below to apply the above steps
power bi slicer